package xyz.ag.DAO;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;

import xyz.ag.Beans.Book;

public interface BookDAOInterface {

	HashMap<String, ArrayList<String>> getAllification() throws SQLException;

	Integer getrecommendedListNmuber() throws Exception;

	ArrayList<Book> getBookLimitpageList(int page, int number) throws SQLException;

	/**
	 * 获得一本书的id 根据名字
	 * @param Book
	 * @return
	 * @throws SQLException 
	 */
	String getOneBookIDforName(String Book) throws SQLException;
	
	/**
	 * 转换方法 用来聚合数据
	 * 提供一本书的id 用来返回书名
	 * @param BookID
	 * @return
	 * @throws SQLException 
	 */
	String getOneBookNameforID(String BookID) throws SQLException;

	String getOneBookPriceforID(String BookID) throws SQLException;
	
	/**
	 * 根据条件查询书籍
	 * @param page
	 * @param number
	 * @param s
	 * @return
	 * @throws SQLException
	 */
	ArrayList<Book> getBookListByCondition(String page, String number, String s) throws SQLException;

	Integer initshowlistnumber(String s) throws SQLException;

	Book shouBookByBookName(String bookname) throws SQLException;

	String getBookcategoryByID(String categoryID) throws SQLException;
}
